SQL Interface
Overview
This function is intended only for power users who know SQL (Structured
Query Language)! Because you have full control over the database using
this interface, it is easy to inadvertently corrupt the database. You cannot
"undo" any action.
Lotto Sorcerer's SQL database is a SQLite database; see the SQLite web
site (at www.sqlite.org) for full information and syntax.
How to Invoke
Use the menu item "Utilities > Database Utilities > SQL Interface" .
Basic Procedure
- Select the lottery you want to work with from the top dropdown menu.
- Enter valid SQL statements in the text box at the bottom.
- Click the "Execute" button.
Window Controls
"Select Lottery" dropdown menu
Use this dropdown to select the lottery that you want to work with.
"Refresh" button
If you executed a SQL command that changed the data, clicking this button
will refresh the view of the table.
"SQL Command" combo box
Enter the SQL command or statement you want to execute in this box.
"Export" button
This will export the results as a Microsoft Excel spreadsheet.
"Copy" button
This will copy the results to your System Clipboard.
"Save" button
This will save the results to a text file.
"Execute" button
This will execute the SQL command you typed in the command box.
"Paste" button
This will paste all text from your System Clipboard into the SQL Command
combo box
Notes:
When you select the lottery in the top dropdown, the name of the table
will be shown at the top-right of the window.
Successfully executed SQL statements will be "remembered" and displayed in
the SQL Command text box as long as you have Lotto Sorcerer running. Use the
dropdown to recall these statements.